﻿<%@ Page Title="" Language="C#" MasterPageFile="~/common/Admin.master" AutoEventWireup="true" CodeFile="maturity_acc.aspx.cs" Inherits="fd_deposit" %>

 <asp:Content ID="leftMenu" ContentPlaceHolderID="leftMenu" Runat="Server">
          <ul>
        
                    <li>
                   <a href="<%= Page.ResolveUrl("~/product/saving/admin/saving_withdrawal.aspx")%>">Savings Account Withdrawal</a></li>
                   <li><a href="<%= Page.ResolveUrl("~/product/fixed_deposit/admin/maturity_acc.aspx")%>">Fixed Deposit Maturity Withdrawal</a></li>
                  
    </ul>

</asp:Content>

<asp:Content ID="Content2" ContentPlaceHolderID="content" runat="Server">
    


    <h1>
        Maturity Account List</h1>

        <br />
        
    <asp:GridView ID="v" runat="server" BorderStyle="None" BorderWidth="1px" 
        CellPadding="3" CellSpacing="2" AutoGenerateColumns="False" 
        DataSourceID="MaturityDataSource">
        <AlternatingRowStyle BackColor="White" />
        <Columns>
            <asp:BoundField DataField="SavingsAccountNo" HeaderText="Savings Account No" 
                SortExpression="SavingsAccountNo" />
                <asp:TemplateField HeaderText="Depositor"   SortExpression="lastname">
                <ItemTemplate>
                <asp:Label ID="Label1" runat="server" Text='<%#Eval("fName")+ " " + Eval("lName")%>' ></asp:Label>

                </ItemTemplate>

                </asp:TemplateField>
            <asp:BoundField DataField="fName" HeaderText="fName" SortExpression="fName" 
                Visible="False" />
            <asp:BoundField DataField="lName" HeaderText="lName" SortExpression="lName" 
                Visible="False" />
            <asp:BoundField DataField="DepositAmount" HeaderText="Deposit Amount" 
                SortExpression="DepositAmount" />
            <asp:BoundField DataField="SavingsAccountType" HeaderText="Savings Account Type" 
                SortExpression="SavingsAccountType" />
            <asp:BoundField DataField="effectiveDate" HeaderText="Effective Date" 
                SortExpression="effectiveDate" DataFormatString="{0:d}" />
            <asp:BoundField DataField="maturityDate" HeaderText="Maturity Date" 
                SortExpression="maturityDate" DataFormatString="{0:d}" />
        </Columns>
        <FooterStyle BackColor="#F7DFB5" ForeColor="#8C4510" />
        <HeaderStyle BackColor="#A55129" Font-Bold="True" ForeColor="White" />
        <PagerStyle ForeColor="#8C4510" HorizontalAlign="Center" />
        <RowStyle BackColor="#FFF7E7" ForeColor="#8C4510" />
        <SelectedRowStyle BackColor="#738A9C" Font-Bold="True" ForeColor="White" />
        <SortedAscendingCellStyle BackColor="#FFF1D4" />
        <SortedAscendingHeaderStyle BackColor="#B95C30" />
        <SortedDescendingCellStyle BackColor="#F1E5CE" />
        <SortedDescendingHeaderStyle BackColor="#93451F" />
    </asp:GridView>
    
            <br />
    <fieldset style="background-color:#FFEBCD">
        <legend style="background-color:#E55B3C;">Withdrawal service</legend>
        <table>
            <tr>
                <td>
                    Transfer S$:
                    <asp:TextBox ID="tbAmount" runat="server"></asp:TextBox>
                    &nbsp;<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" 
                        ControlToValidate="tbAmount" ErrorMessage="Please enter the amount" 
                        ForeColor="Red"></asp:RequiredFieldValidator>
                    <br />
                    <br />
                    Savings Account
                    Type:&nbsp; 
                    <asp:DropDownList ID="ddlType" runat="server" AutoPostBack="True">
                        <asp:ListItem Value="ps">Power Save Account</asp:ListItem>
                        <asp:ListItem Value="ks">Kids Saver Account</asp:ListItem>
                    </asp:DropDownList>
                    <br />
                    <br />
                    Account Number:&nbsp;&nbsp;&nbsp;
                    <asp:TextBox ID="tbTo" runat="server"></asp:TextBox>
                    &nbsp;<asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server" 
                        ControlToValidate="tbTo" ErrorMessage="Please enter the account number" 
                        ForeColor="Red"></asp:RequiredFieldValidator>
                    <br />
                    <br />
                </td>
            </tr>
            <tr>
                <td>
                    &nbsp;
                    <asp:Button ID="btnSubmit" runat="server" 
                        Text="Submit" onclick="btnSubmit_Click" />
                    <asp:Button ID="btnReset" runat="server" Text="Reset" />
                </td>
            </tr>
        </table>
    </fieldset><br />
    
            <br />
    <asp:SqlDataSource ID="MaturityDataSource" runat="server" 
        ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
        SelectCommand="SELECT [SavingsAccountNo], [fName], [lName], [DepositAmount],[SavingsAccountType],[effectiveDate], [maturityDate]FROM [FIXED_DEPOSIT] WHERE (maturityDate=CAST(GETDATE() AS DATE))"></asp:SqlDataSource>
    
            <br />
    
    
            </asp:Content>




